UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ts3B1RJ7XYTvARwbqSDOgag2o846qJynLmT/+vZXidE='
WHERE
key_id = 'd33e2089deec56ec4dabeb2e6742b161ec6822fcd16749fd8f9b02342fde3fb8'
AND (
token = 'ts3B1RJ7XYTvARwbqSDOgag2o846qJynLmT/+vZXidE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)