UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P7RTlfpy6jxIfWL5YYGZSV7r0DrQMrJJBb2iPI9jxrE='
WHERE
key_id = '889ae0d64273005c6281caf9eb76e99a09a84f1f26d8e14d70f76dd28e81faa2'
AND (
token = 'P7RTlfpy6jxIfWL5YYGZSV7r0DrQMrJJBb2iPI9jxrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)