my $query = "

        my $query = "

            UPDATE reserves

            UPDATE reserves

            SET    cancellationdate = now(),

            SET    cancellationdate = now(),

                   priority         = 0

                   priority         = 0

            WHERE  reserve_id = ?

            WHERE  reserve_id = ?

        ";

        ";