UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XeZim4mDAn9rXJVCRqUs5yqASVkTJLMbGQvlQ8ctvNs='
WHERE
key_id = 'b997efab1dd3225781a11f525139390c1fa2a9f39375ce5b8298f243264656bb'
AND (
token = 'XeZim4mDAn9rXJVCRqUs5yqASVkTJLMbGQvlQ8ctvNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)