UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D1gwnTnCjUPyQdZd76VQ8mVb3V8HU+NC/7KU720kN3Q='
WHERE
key_id = 'b85f72168acd38cf5d31761fab5f1519c0432c878c236edb244a1c1a64474d65'
AND (
token = 'D1gwnTnCjUPyQdZd76VQ8mVb3V8HU+NC/7KU720kN3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)