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