UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whRDQZUHeGdOA1rw2lbNgK9w7szsGGjOEmHL3EULuZo='
WHERE
key_id = '82d1dfb1f62ee3015a171ce2ac6398d737d2d2def1437d0e344dd7b9014021b8'
AND (
token = 'whRDQZUHeGdOA1rw2lbNgK9w7szsGGjOEmHL3EULuZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)