UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Oae3bwusk4ZqXAMTc/2YuqOfNT8AtWKB+y8XOWJztY='
WHERE
key_id = 'ed4d064bfdd998b11e7fb25d4726f982afff021d0d849f76e3b5819b76ce7a15'
AND (
token = '0Oae3bwusk4ZqXAMTc/2YuqOfNT8AtWKB+y8XOWJztY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)