SELECT COALESCE(status,'not a valid token') AS status,last_sync_data_time FROM
(
SELECT
CASE WHEN CURRENT_TIMESTAMP <= license_end_date THEN 'valid' ELSE 'expired' END AS status, last_sync_data_time
FROM adempiere.license_tomato_app
WHERE key = '7EF3D9B8183D9C7AB90242AF5D011ABE'
union all
select null, '1900-01-01 00:00:00' last_sync_data_time where not exists (select 1 from adempiere.license_tomato_app WHERE key = '7EF3D9B8183D9C7AB90242AF5D011ABE')
) t