SuperTokens is an open source authentication solution offering features like: Different types of login: Email / password, Passwordless (OTP or Magic link based).

SuperTokens.com

await this.prisma.emailpassword_users.update({
      where: { user_id },
      data: { email: newEmail },
    });
    await this.prisma.emailverification_tokens.update({
      where: { user_id_email_token: { user_id, email: null, token: null } },
      data: { email: newEmail },
    });
    await this.prisma.emailverification_verified_emails.update({
      where: { user_id_email: { user_id, email: null } },
      data: { email: newEmail },
    });