UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T5Xr1DvXLyi3APIxluw1RaK5XVeXss3uW7V8GBDLYp0='
WHERE
key_id = '49041d0ebf2742da7d476e13c3f0ca123f448b7ddc0d5d45f8d9115ff8bf8b51'
AND (
token = 'T5Xr1DvXLyi3APIxluw1RaK5XVeXss3uW7V8GBDLYp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)