A simple PHP script to delete expired auth type concrete cookies

clean-expired-cookies.php

<?php

use Carbon\Carbon;

defined('C5_EXECUTE') or die('Access Denied.');
/**
 * @author: Biplob Hossain <biplob.ice@gmail.com>
 */

$db = app('database/connection');
try {
    $results = $db->executeQuery(sprintf('SELECT * FROM authTypeConcreteCookieMap WHERE validThrough < %d',  Carbon::now()->timestamp));
    foreach ($results as $result) {
        if (Carbon::createFromTimestamp($result['validThrough'])) {
            echo t('Deleting the record with the ID: %d, Valid Through: %s', $result['ID'], Carbon::createFromTimestamp($result['validThrough'])->toDateTimeString()) . PHP_EOL;
            $db->delete('authTypeConcreteCookieMap', ['ID' => $result['ID']]);
        }
    }
} catch (\Doctrine\DBAL\Exception $e) {
    app('log/exceptions')->error($e->getMessage());
}