UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mlIAolwnFIAtSQ1MUAnvLUchVI1Vs/gF5aC6u+kF4mE='
WHERE
key_id = '6a81976c3c4bcd9d94cc12eebc265c4ea6a6aea47c82472ebcc1b385fa3ec654'
AND (
token = 'mlIAolwnFIAtSQ1MUAnvLUchVI1Vs/gF5aC6u+kF4mE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)