UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4FpXhpIbt7VY9fgQpT7mNdDoxA8RYFuY0sXG2FSaPmQ='
WHERE
key_id = '8767d7e434a66d0a50ff9efacedb370351ae49cd0fbf6260ef6aa0bc0b3e2a72'
AND (
token = '4FpXhpIbt7VY9fgQpT7mNdDoxA8RYFuY0sXG2FSaPmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)