You can not use where clause on non unique fields as described in the documentation https://www.prisma.io/docs/orm/prisma-client/queries/crud#update. I was also facing the same problem and had to use @unique on my schema.