UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OlnCVAY68NX0i71gXcOw0XDUKQUKR16ZCE2+fyXgwd8='
WHERE
key_id = 'e47dfc1cda755ad7eca4648c09d75192bcd147056d99d0632830ac0dfdfbd7df'
AND (
token = 'OlnCVAY68NX0i71gXcOw0XDUKQUKR16ZCE2+fyXgwd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)