UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jLWX4929O5iYE9/highM6MZp7EvhrEWzVu0M5iQYkbw='
WHERE
key_id = '626c7afc59ff02f31c4e4b48c2e30a7aef12d9db918387412dd9ec53e894ff1f'
AND (
token = 'jLWX4929O5iYE9/highM6MZp7EvhrEWzVu0M5iQYkbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)