UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MkmtXXYU2iLdps4Q4/z4gry/1YpY+M05c7CQw7hT+7s='
WHERE
key_id = 'e6f78208a486bf24cac0074cbb502e88192736a242397c1ac3173272e9445ee5'
AND (
token = 'MkmtXXYU2iLdps4Q4/z4gry/1YpY+M05c7CQw7hT+7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)