UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3kqIAmC87HisOrzK6Osu3umqsho06793acTC4SNnQBU='
WHERE
key_id = 'ce1c982102a84340131fbb213cd30c8d6b44afcd093bfc91b1b3493f2c7e93b3'
AND (
token = '3kqIAmC87HisOrzK6Osu3umqsho06793acTC4SNnQBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)