UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PFbkeBakKDzkHbWKaVzwY8YYJ2EQos5gf1pfC//qUsg='
WHERE
key_id = '249354085d73005f57b12965b5794818d98d4d933fb386a5dc9136dd2c98ffef'
AND (
token = 'PFbkeBakKDzkHbWKaVzwY8YYJ2EQos5gf1pfC//qUsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)