UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3K6/IY5QG8ZMjbrQhzLLS+hsZDXAAVn0gsOyy0KW9n0='
WHERE
key_id = '31b107f1bdfaaf042409fd9a27aba896f122208ab19a73cf2c4181bb2c527426'
AND (
token = '3K6/IY5QG8ZMjbrQhzLLS+hsZDXAAVn0gsOyy0KW9n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)