UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nrfeMACREsP0i6x0pmlIGTTp2sfKRzZJKuNfnUOd4E='
WHERE
key_id = '407e74f1de9942173fadcf6a2f1b0ec267e04a9b0a5e1d28c07d302e926e46c9'
AND (
token = '8nrfeMACREsP0i6x0pmlIGTTp2sfKRzZJKuNfnUOd4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)