UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BesmIdEmRqPkt94+3tKlOowvKvPShOjFa5scZA+hYI='
WHERE
key_id = '977b8089aa47aaa960c941619a545acf1d9a46ce7a6d7e4f7772306fde9dabf3'
AND (
token = '7BesmIdEmRqPkt94+3tKlOowvKvPShOjFa5scZA+hYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)