UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BP/vmFnJj5nr1sM4XhFgS6+SSTJ5dYt7sJtbi6/oJxo='
WHERE
key_id = '95d1c70825127b382d3a865227a3dea664287fe511ebd99c1c1771da32abbb15'
AND (
token = 'BP/vmFnJj5nr1sM4XhFgS6+SSTJ5dYt7sJtbi6/oJxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)