UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4oiW9T8AKTUkx4zwwA1k6o5vhTqwUjnnegzejUzueYY='
WHERE
key_id = '7a87f622fb96ec0bf31dfa1832f3b324ca1b04952f8d50a65e0a95f734534831'
AND (
token = '4oiW9T8AKTUkx4zwwA1k6o5vhTqwUjnnegzejUzueYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)