UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VMCVxkGuEfml5oV4ApP9ooHy21xnRsS01Q8WmoClWhY='
WHERE
key_id = '6227c5a9766ac438274e41e98b91118c4c597087f2e4ad4148aa00deb5f428df'
AND (
token = 'VMCVxkGuEfml5oV4ApP9ooHy21xnRsS01Q8WmoClWhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)