UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4R7ygsFe1fyuwpZt14OR03u1hiOKVlIPTrFCldd+9PU='
WHERE
key_id = '2f96d0c64f1e78e913338e2c2cb93d4766e7b31dd4e77f4712592f0686c043bf'
AND (
token = '4R7ygsFe1fyuwpZt14OR03u1hiOKVlIPTrFCldd+9PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)