UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nbBW8fc1ocyWfdB4Q5V5PZfF2ceLHa7P88yOl3u70c='
WHERE
key_id = '171a8b4c953dc3f53ba84bc569bc11a3fa36835a2ec8ae8feb99181611f226d3'
AND (
token = '8nbBW8fc1ocyWfdB4Q5V5PZfF2ceLHa7P88yOl3u70c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)