UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DyWD1j4ubdQTw77t8o/lo5/97MiUAjPdalTfoqw5Xg='
WHERE
key_id = '3181278f3ae998c2cf1480c87af003f23e2a51c1dd6a96e3e65b94b83b82441c'
AND (
token = '9DyWD1j4ubdQTw77t8o/lo5/97MiUAjPdalTfoqw5Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)