UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rQvU3umTAqa0ofmJzC7k1O671LzeG9MHkzhdqOG+s0A='
WHERE
key_id = '9aafbbb020209d24a34f1a46fabad250f772b7053e4d813951cd2c0844671210'
AND (
token = 'rQvU3umTAqa0ofmJzC7k1O671LzeG9MHkzhdqOG+s0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)