UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lmk0KfAgsJ7e39Q5H8BA7ZpfoLHIofSa1EOzsSvghSI='
WHERE
key_id = 'c0fb7dd535423e7b2899bb988b4081c2c8c4cc6a58ed094c09d7997dcaf4cf93'
AND (
token = 'Lmk0KfAgsJ7e39Q5H8BA7ZpfoLHIofSa1EOzsSvghSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)