UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vYrT7lG1sOLAQ6Ut0IOi8B5OJ53L9F314/PhngIYsOY='
WHERE
key_id = '97c123d47057566c3011350afd715e895209800d5256031d157ce39774dccdf8'
AND (
token = 'vYrT7lG1sOLAQ6Ut0IOi8B5OJ53L9F314/PhngIYsOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)