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