UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihPyq/6guFz5Y6PETBOWxda4EnIWKFtOITGz8ZYeIkw='
WHERE
key_id = '7f6f05dfc3f716301630ed95f7c32899de272706b020dc20bf6a4a90591554f9'
AND (
token = 'ihPyq/6guFz5Y6PETBOWxda4EnIWKFtOITGz8ZYeIkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)