UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hvs6ooktybogLRqRyyynqhhkuT45KMRc1rDs2LRfGWA='
WHERE
key_id = '2e0d06c4a9cee3af9c16eda4de7f4e7a0a86efbd1d08d7fb36284a2a6206002e'
AND (
token = 'hvs6ooktybogLRqRyyynqhhkuT45KMRc1rDs2LRfGWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)