UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z89mf2VQQEe2qtHTAIAgnSgDjEHG6LmpUI+ccrXby6A='
WHERE
key_id = 'f49404468e788546b4151aa177fd1fc3b4b72fb5994c722e4a0821b97923c66b'
AND (
token = 'Z89mf2VQQEe2qtHTAIAgnSgDjEHG6LmpUI+ccrXby6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)