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