UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prCILnALfZE0PcIT4ldILCTWLhbxJrZgIVCmhKvkwzE='
WHERE
key_id = '77856ada9b8f3d6289411aa052bba384a245fc24d21d59e66b14f78a7aba86f5'
AND (
token = 'prCILnALfZE0PcIT4ldILCTWLhbxJrZgIVCmhKvkwzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)