bug: api keys authentication does not work

[Meierschlumpf]

Provide environment information

System:
- OS: Windows 11 10.0.22631
- CPU: (20) x64 12th Gen Intel(R) Core(TM) i7-12700H
- Memory: 5.45 GB / 31.73 GB
Binaries:
- Node: 22.11.0 - C:\Program Files\nodejs\node.EXE
- Yarn: 1.22.22 - ~\AppData\Local\pnpm\yarn.CMD
- npm: 10.9.0 - C:\Program Files\nodejs\npm.CMD
- pnpm: 9.13.2 - C:\Program Files\nodejs\pnpm.CMD

Describe the bug

When checking the api key and creating a session it does not work as it compares the unhashed with hashed key.

const apiKeyFromDb = await db.query.apiKeys.findFirst({
    where: eq(apiKeys.apiKey, apiKeyHeaderValue),
    columns: {
      id: true,
      apiKey: false,
      salt: false,
    },
    with: {
      user: {
        columns: {
          id: true,
          name: true,
          email: true,
          emailVerified: true,
        },
      },
    },
});

Link to reproduction

http://localhost:3000/manage/tools/api

To reproduce

1. Go to http://localhost:3000/manage/tools/api
2. Create a api key
3. Use the api key to get all users
4. It fails with unauthorized

Additional information

No response