<?php
define("DB_HOST", "localhost");
define("DB_USER", "ccah_user");
define("DB_PASS", "e_NQ,S^#sW6X:;nV!Uw.my");
define("DB_NAME", "ccah_assessment");

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
    die("Database connection failed: " . $conn->connect_error);
}

// Mark expired tokens
$conn->query("UPDATE users SET expired = 1 WHERE expiry_date < NOW() AND expired = 0");

?>