UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOFol/eSvs45wSU1xN9jDzswH56ajcmIYsQ1A4FoHQA='
WHERE
key_id = 'ff7f128b0ec8c3c08446143b480c1be1a3b865b7d04cc015a95d206def0ec197'
AND (
token = 'mOFol/eSvs45wSU1xN9jDzswH56ajcmIYsQ1A4FoHQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)