UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNPHljkH90YmwpJdunFQbjGNvn7CSqgis7Rh+GHWhU4='
WHERE
key_id = '16cf3ce2c07c009bdabff7b960d82b1bf5a5a42d3feb98f6a86cd176e3817311'
AND (
token = 'SNPHljkH90YmwpJdunFQbjGNvn7CSqgis7Rh+GHWhU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)