UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jz9bXK4dLEZwTWn2rlagL7qhNem1rhey3I9rlFWL+14='
WHERE
key_id = '3c6006d5a8838cf534a13dcea60f7c5ceb909d0d344eddd1a5eabf3e6238543a'
AND (
token = 'jz9bXK4dLEZwTWn2rlagL7qhNem1rhey3I9rlFWL+14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)