PaymentIntent id rejected because already used

Unfortunately I am also running into this issue for one customer. He has purchased items before, and now when he tries to go through the checkout, he has the same payment intent ID, preventing him to checkout.

"error": {
    "code": "payment_intent_unexpected_state",
    "doc_url": "https://stripe.com/docs/error-codes/payment-intent-unexpected-state",
    "message": "You cannot confirm this PaymentIntent because it has already succeeded after being previously confirmed.",
    "payment_intent": {
      "id": "pi_*************",
      "object": "payment_intent",
      "amount": 144,
      "amount_details": {
        "tip": {
        }
      },
      "automatic_payment_methods": null,
      "canceled_at": null,
      "cancellation_reason": null,
      "capture_method": "automatic",
      "client_secret": "******************",
      "confirmation_method": "automatic",
      "created": 1739086429,
      "currency": "cad",
      "description": null,
      "last_payment_error": null,
      "livemode": true,
      "next_action": null,
      "payment_method": "pm_***************",
      "payment_method_configuration_details": null,
      "payment_method_types": [
        "card"
      ],
      "processing": null,
      "receipt_email": null,
      "setup_future_usage": null,
      "shipping": null,
      "source": null,
      "status": "succeeded"
    },
    "request_log_url": "https://dashboard.stripe.com/logs/req_***********",
    "type": "invalid_request_error"
  }

I tried to remove the stripe data from the commerce_order table in the database, hoping it would create a new payment intent, but I think there is caching or something else working because the 'data' column was updated/reverted with the same payment intent ID after I ran

 update commerce_order set data = '' where order_id = 127419;