MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.6.9-MariaDB-1:10.6.9+maria~deb11


create table channel_titles (
  entry_id int,
  title varchar(10),
  expiration_date int(11) default 0
  );

insert into channel_titles
values
(1, 'test1', 1695513600),
(2, 'test2',  0),
(3, 'test3', 1662768000)
SELECT entry_id, title, (CASE WHEN expiration_date = "0" THEN CURDATE() + INTERVAL 1 DAY ELSE FROM_UNIXTIME(expiration_date, "%Y-%m-%d") END) AS exp_date
    FROM channel_titles
    HAVING CURDATE() < exp_date


entry_id
title
exp_date


1
test1
2023-09-24

2
test2
2022-09-15