UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qAuTsd6IfDMaeDwH5cd/kd4mLFayfL6fJzfJX3Pln8='
WHERE
key_id = 'f7f34e9608d8f493a3a9df1456f73fc66649a3593a05e576eb286aecbb00873a'
AND (
token = '9qAuTsd6IfDMaeDwH5cd/kd4mLFayfL6fJzfJX3Pln8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)