UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k00Aaj4W7NXToTGWqyOZuPci53wTZrHoK5wwmj3M81k='
WHERE
key_id = 'e12ddf847ffa5bd5039261a74a68398ab5e2ac429d380a47480c14c01aabfba1'
AND (
token = 'k00Aaj4W7NXToTGWqyOZuPci53wTZrHoK5wwmj3M81k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)