Web Push Subscriptions are not cleared when users delete their accounts

[pixeldesu]

Steps to reproduce the problem

1. Enable push notifications
2. (do something that prompts a notification on the subscribed device)
3. Delete your account

Expected behaviour

Nothing.

Actual behaviour

An error in the Webpush queue appears at some point:

[ERROR] Rpush::DeliveryError, Unable to deliver notification {id}, received error 410 (Gone: push subscription has unsubscribed or expired.
[ERROR] [webpush] {id} failed: Gone: push subscription has unsubscribed or expired.

Detailed description

No response

Specifications

Retrospring 2023.1019.0