UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0Z7Y2eHMHIWgz5bpbZy+Wwa34HESPAAo4VQJqNbat4='
WHERE
key_id = '9b064487794ba84f9a74de02cca278977eddf018495afd9cade07cb23d28a0cc'
AND (
token = 'z0Z7Y2eHMHIWgz5bpbZy+Wwa34HESPAAo4VQJqNbat4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)