Delete Records with Condition

SQL

Technical Specification

Delete all rows from password_reset_tokens table where created_at is older than 30 days.

Input/Output Samples

Input:tokens older than 30 days

Output:Cleaned up tokens

Optimal Logic Path

DELETE FROM password_reset_tokens
WHERE created_at < NOW() - INTERVAL '30 days';

Architectural Deep-Dive

Periodic cleanup keeps your tables small and protects from storing stale sensitive data.