UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KLdbKrHU1IVOhUB7wooRkgiw4VwveaHXhe3N9wvZlM0='
WHERE
key_id = 'eb937b7594f0bb4ec54099f413367a494466ac566ed46f2ce51d62df78403dbd'
AND (
token = 'KLdbKrHU1IVOhUB7wooRkgiw4VwveaHXhe3N9wvZlM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)