How does the token status change in the system when an operation is canceled in the database?

When an operation is canceled in a database related to the use of a token (for example, for authentication or authorization), the token's status is usually changed to "cancelled" or "invalid." This is done to prevent further use of the token after the operation has been interrupted or rolled back.

In C#, this might look like: after rolling back a transaction, the token's status field in the database is updated, for example:

using (var transaction = connection.BeginTransaction())
{
    try
    {
        // Perform database operations

        transaction.Commit();
    }
    catch
    {
        transaction.Rollback();
        // Update token status
        UpdateTokenStatus(tokenId, "Cancelled");
    }
}

void UpdateTokenStatus(string tokenId, string status)
{
    // Logic to update the token status in the database
}

Thus, canceling an operation is accompanied by changing the token's status to ensure the system's correct state and security.