UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VWwdOh5qMWvnUCCnYy8w/8GcOdRntosS0/eLf+mlk8='
WHERE
key_id = '704bb7435e9ff183ffdd6798d4dbf7360c437b792eed99f26ab27706e4d67f93'
AND (
token = '3VWwdOh5qMWvnUCCnYy8w/8GcOdRntosS0/eLf+mlk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)