UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z0KcklukcN6dl1RdSx40+UlEDk3Cy5gENpnLlxVcOM8='
WHERE
key_id = '1455f073e2dc6a7fe1d0c1ce5d2f8c8169d62349ff765bf6ed4796405329b8c3'
AND (
token = 'Z0KcklukcN6dl1RdSx40+UlEDk3Cy5gENpnLlxVcOM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)