UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZO0Ly9jxQvqsU2d3rgqfsMZiBh1/7QpJS3bYyG05qI='
WHERE
key_id = '31612014bc4cbdd52ae77151ce48fc43954b7e639c8ed0654f26fea36d0fd4cd'
AND (
token = '0ZO0Ly9jxQvqsU2d3rgqfsMZiBh1/7QpJS3bYyG05qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)