UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9EtFyRlHHneDGCkJSX46Ltl7WGO2apWjZus87fUA4cI='
WHERE
key_id = '6c7f4ddd5aafca2926ae4c555d26c9ba2defcd381fc1d5625257e4092818dcd1'
AND (
token = '9EtFyRlHHneDGCkJSX46Ltl7WGO2apWjZus87fUA4cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)