Hi all! Quick question.

I'm using prisma orm and I have a schema that looks like this:

model User {
    id           Int                   @id @default(autoincrement())
    username     String                @unique
    password     String
    sessionToken String                @unique
}

and I was thinking of how to generate unique session tokens efficiently. The only approach I could think of was something like this which would likely be put in my middleware as well as a server action on initial sign up:

while (true) {
    const newToken = generateNewToken();

    const userWithToken = await prisma.user.findFirst({
        where: {
            sessionToken: newToken
        }
    });

    // no collision
    if (userWithToken === null) {
        await prisma.user.update({
            where: {
                id: myUserId
            },
            data: {
                sessionToken: newToken
            }
        });

        break;
    }
}

but this is two queries to my database AND has the (statistically improbably) possibility of needing to run twice, thrice, etc. Is there a better way? How do you guys do it? Thanks!