UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eaMwlGt6ztaOORM9IbUhR8fYqjivzJT+ZwsEA0XUFXo='
WHERE
key_id = '916204f2947ca97c5a24d08479e7d71f9d2fa7f5db8c8da0c9a1d2a0e968ce0a'
AND (
token = 'eaMwlGt6ztaOORM9IbUhR8fYqjivzJT+ZwsEA0XUFXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)