Since you don't get SUPER with Cloud SQL, the only way that you can kill a query is to login as the user who owns it and kill it.
We keep an (encrypted) plaintext copy of all of our user and application passwords so that we can kill a runaway query if we ever need to.