Update failed payment rows for subscription leads

Failed subscription payments lack campaign context, leaving campaign managers and billing staff blind. Log each failed payment with timestamp so queues update before next billing run.