UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '19xqrR6QwVoqqtZnmachxn8sw3sjm8XD1d7o3KE72t4='
WHERE
key_id = '17fefb035b3325e1a326527278fd53a94bdcb43ff5101633f0dafe7cc3ce6620'
AND (
token = '19xqrR6QwVoqqtZnmachxn8sw3sjm8XD1d7o3KE72t4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)