UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0bfTsQAcNAqyXDarpN0jz4WFQPhABPgjAyGTev5vSFI='
WHERE
key_id = '47b86e37f88a982c6718c8021be64da170b00bda53b7c7273dd9833a84fc5139'
AND (
token = '0bfTsQAcNAqyXDarpN0jz4WFQPhABPgjAyGTev5vSFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)