UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HW8sVhHDhV5hYj//Ulc7qxhOh0nEhuZmJtngn9Fnrws='
WHERE
key_id = 'b96d2eb8b2b8177965335b6ce149a12b1b03d43e10f5adf4e4a9dcaeba0600f1'
AND (
token = 'HW8sVhHDhV5hYj//Ulc7qxhOh0nEhuZmJtngn9Fnrws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)