UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ksJRpywjtfluPIWj5SdL8bQCqFOntxGHR0cTgBADzs='
WHERE
key_id = '3f3f71a7ff9a36d108849006505dfdc8e5f08761deed06ea0d1fc0e342fad5ef'
AND (
token = '1ksJRpywjtfluPIWj5SdL8bQCqFOntxGHR0cTgBADzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)